1.Tell about your self?

2. Diff B/w Views and MViews?
 How will get refreshed automatically and manully

3. Explain DBMS_OUTPUT and RAISE Application Error

4.Diff b/w Procedure and Function
If possible to perform DML inside the function
what will happen if you put more then one return statement inside the function
 
5. Possible to commit inside the trigger

6. What is use of cycle and catch in sequence ?
Is it possible to modified sequence how ?

7. Explain full outer join

8. Have you used index in your project ( Global and Local Index)

9. have you used Hints in your project ?

10. Explain Mutating error in trigger

11. Have you used sqlloader in your project ?( Append, Insert)

12. Diff b/w Nested table and Varrays

13. Diff b/w Associative array and Varrays

14. Diff b/w Stand alon Procedure and Procudure Inside the package

15. In Production we have huge volume of data how will you create table partition and different type of partition

16.What is procedure overloading